February 18, 2018

Slide Layout


  • CNN Apprehension Summary Report.
  • Wall Pledge Reality.
  • Apprehension Analysis.
    • 2000-2017 Apprehension Summary.
    • 2010 Vs 2017 Apprehension by Sector.
  • Data Visualization
  • Sector Statistical Plots.
    • Highest Apprehension per Sector

CNN Report Summary

US-Mexico boarder apprehensions have been steadily declining since 2000, and in April of 2017 they reached historic lows. These downward trends and record lows can be accredited to President Trump’s election. The data shows that President Trump’s aggression towards immigration laws is having a deterring effect, and migrants are less enticed to enter the country.





CNN Report Summary Cont..

DHS credits the administration policy as the lowest apprehensions prior to this past April were in December of 2011. This new low is 7,000 apprehensions less than the previous. In a year since April 2016, apprehensions were down 62%, though there are multiple different reasons for such a change. Throughout these slides you can find the monthly summaries of apprehensions by sector in a time series from 2000 to 2017 depicting the changes throughout time. But first, on the next slide will be the video linked to this report.

Trumps Border Wall Pledge Vs. Reality:

Apprehension Analysis

The following graph represents a Summary of the Apprehensions made at the US-Mexico border between the years 2000 through the year 2017. Each green marker represents the average apprehension rate for that year.

Apprehension Summary Analysis

It is seen from the previous slide that Apprehensions throughout time have been slowly decreasing, and it is now as low as it once was back in the year 2011. This is being accredited to Donald Trumps aggression on border patrol and the desire to build a higher wall to prevent the US from having Mexicans or anybody fleeing their country to illegally cross the border into the states

Top 3 Month Periods with the most Apprehensions

Looking at the data and being able to manipulate and run a quick analysis on the apprehensions for both 2010 and 2017 we came up with the following conclusions for the most apprehensions in those years respectively by using the following R scrypt:

ts1 <- read.csv('PB monthly summaries.csv',row.names=1)
mat <- as.matrix(ts1)

#top 3 apprehensions per year in 2010 and 2017
max_apps_2010 <- tail(sort(mat["2010", ]), 3)
max_apps_2017 <- tail(sort(mat["2017", ]), 3)

Scrypt Output

Top 3 highest Apprehensions for the year 2010 Top 3 highest Apprehensions for the year 2017
61361 for the month of March 46184 for the month of October
55237 for the month of April 47211 for the month of November
47045 for the month of May 43251 for the month of December



Depicted in the table above, it is noted that the maximum apprehensions in the year 2010 were 61361 in the month of March, and the maximum apprehensions in the year 2017 were 47211 in the month of November.

Change in Maximum Apprehensions

Using simple statistical tests like those demonstrated in class we were able to compare the sector with the most apprehensions in 2010 with the sector with the most apprehensions in 2017. The difference in the maximum apprehensions for each year was a total of 14150. Noting that Apprehensions since the year 2010 were significantly lower in 2017.

Big Bend Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of October in the year 2017

Big Bend Table

October November December January February March April May June July August September
2010 530 421 373 433 484 660 575 493 415 280 295 329
2017 697 603 477 473 383 357 413 552 378 492 563 614

Del Rio Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of October in the year 2017

Del Rio Table

October November December January February March April May June July August September
2010 1119 897 697 1234 1245 1874 1791 1718 1326 767 1095 931
2017 2106 1880 1817 1243 1104 746 589 740 761 760 798 932

El Centro Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of March in the year 2010

El Centro Table

October November December January February March April May June July August September
2010 2589 2412 2196 2688 2836 4408 3419 3126 2440 2331 2075 2042
2017 2441 1850 1870 1796 1196 871 849 1134 1280 1478 1880 1988

El Paso Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of November in the year 2017

El Paso Table

October November December January February March April May June July August September
2010 1007 894 725 1124 1140 1528 1359 1380 1005 725 732 632
2017 3973 4105 3948 2779 1575 978 906 1032 1180 1395 1782 1540

Laredo Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of April in the year 2010

Laredo Table

October November December January February March April May June July August September
2010 2613 2130 1802 2526 3173 4433 4528 3813 3475 1857 2819 2118
2017 3350 3194 2460 2265 1710 1256 1304 1722 1839 2120 2143 2097

Rio Grande Valley Apprehensions

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of November in the year 2017

Rio Grande Valley Table

October November December January February March April May June July August September
2010 4236 3688 2987 3658 4845 7141 7139 7477 5595 3832 5329 3839
2017 22642 24686 23418 15580 7855 4147 3942 4882 5817 7107 8650 8836

SanDiego Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of March in the year 2010

SanDiego Table

October November December January February March April May June July August September
2010 5017 4738 4636 6413 6982 9061 7115 5858 5092 5113 4528 4012
2017 2934 2947 3099 2927 1808 1356 1392 1724 1652 1764 2241 2242

Tucson Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of March in the year 2010

Tucson Table

October November December January February March April May June July August September
2010 23197 16986 10907 16122 21266 31197 28579 22572 13160 10303 9280 8633
2017 5924 5912 4303 3357 2589 2148 1487 2199 2632 2177 2913 3016

Yuma Apprehension Analysis

Depicted from the plot above it can be seen that the most apprehensions for this sector happened in the month of October in the year 2017

Yuma Table

October November December January February March April May June July August September
2010 582 649 711 586 819 1059 732 608 447 401 262 260
2017 2117 2034 1859 1156 534 336 245 534 548 894 1318 1272